package com.goods.business.mapper;

import com.goods.common.model.business.Product;
import com.goods.common.vo.business.ProductStockVO;
import org.apache.ibatis.annotations.Param;
import tk.mybatis.mapper.common.Mapper;

import java.util.List;

public interface ProductMapper extends Mapper<Product> {


    List<Product> findProductList(String name, Long categoryId, int status);

    int removeById(Long id);

    int back(Long id);


    Product selectBypNum(String pNum);

    List<ProductStockVO> selectProductStockVOList();

    List<ProductStockVO> selectProductStockVOListByStatus(@Param("name") String name,
                                                          @Param("categoryId") Long categoryId,
                                                          @Param("status") int status);
}
